<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>主要内容区main</title>
<link href="../../public/admin/css/css.css" type="text/css" rel="stylesheet" />
<link href="../../public/admin/css/main.css" type="text/css" rel="stylesheet" />
<link rel="shortcut icon" href="images/main/favicon.ico" />
<style>
#searchmain{ font-size:12px;}
#search{ font-size:12px; background:#548fc9; margin:10px 10px 0 0; display:inline; width:100%; color:#FFF; float:left}
#search form span{height:40px; line-height:40px; padding:0 0px 0 10px; float:left;}
#search form input.text-word{height:24px; line-height:24px; width:180px; margin:8px 0 6px 0; padding:0 0px 0 10px; float:left; border:1px solid #FFF;}
#search form input.text-but{height:24px; line-height:24px; width:55px; background:url(../../public/admin/images/main/list_input.jpg) no-repeat left top; border:none; cursor:pointer; font-family:"Microsoft YaHei","Tahoma","Arial",'宋体'; color:#666; float:left; margin:8px 0 0 6px; display:inline;}
#search a.add{ background:url(../../public/admin/images/main/add.jpg) no-repeat -3px 7px #548fc9; padding:0 10px 0 26px; height:40px; line-height:40px; font-size:14px; font-weight:bold; color:#FFF; float:right}
#search a:hover.add{ text-decoration:underline; color:#d2e9ff;}
body{overflow-x:hidden; background:#f2f0f5; padding:15px 0px 10px 5px;}
#main-tab{ border:1px solid #eaeaea; background:#FFF; font-size:12px;}
#main-tab th{ font-size:12px; background:url(../../public/admin/images/main/list_bg.jpg) repeat-x; height:32px; line-height:32px;}
#main-tab td{ font-size:12px; line-height:40px;}
#main-tab td a{ font-size:12px; color:#548fc9;}
#main-tab td a:hover{color:#565656; text-decoration:underline;}
.bordertop{ border-top:1px solid #ebebeb}
.borderright{ border-right:1px solid #ebebeb}
.borderbottom{ border-bottom:1px solid #ebebeb}
.borderleft{ border-left:1px solid #ebebeb}
.gray{ color:#dbdbdb;}
td.fenye{ padding:10px 0 0 0; text-align:right;}
.bggray{ background:#f9f9f9}
#addinfo{ padding:0 0 10px 0;}
input.text-word{ width:50px; height:24px; line-height:20px; border:#ebebeb 1px solid; background:#FFF; font-family:"Microsoft YaHei","Tahoma","Arial",'宋体'; text-align:center; color:#666}
.tda{width:100px;}
.tdb{ padding-left:20px;}
td#xiugai{ padding:10px 0 0 0;}
td#xiugai input{ width:100px; height:40px; line-height:30px; border:none; border:1px solid #cdcdcd; background:#e6e6e6; font-family:"Microsoft YaHei","Tahoma","Arial",'宋体'; color:#969696; float:left; margin:0 10px 0 0; display:inline; cursor:pointer; font-size:14px; font-weight:bold;}
</style>
</head>
<body>
	<?php
		//判断是否 有执行条件
		//var_dump($_GET['search']);
		if(isset($_GET['search'])){
			$where = "where name='{$_GET['search']}'";
			$url = "&search={$_GET['search']}";
		}else{
			$where = "";
			$url = "";
		}
		
		
		//默认下 现在是第一页
		$nowPage = isset($_GET['page']) ? $_GET['page'] : 1;
		//一页显示几行
		$count = 9;
		//当前页面从 第几条开始
		$start = ($nowPage - 1)*$count;
		
	?>
	
	


<!--main_top-->
<form method="post" action="">
<table width="99%" border="0" cellspacing="0" cellpadding="0" id="searchmain">
  <tr>
    <td width="99%" align="left" valign="top" id="addinfo">您的位置：板块列表</td>
  </tr>
  <tr>
    <td align="left" valign="top">
    <table width="100%" border="0" cellspacing="0" cellpadding="0" id="search">
  		<tr>
   		 <td width="90%" align="left" valign="middle">
	         <form method="get" action="./bankuailiebiao.php">　　　　
	         <!--<input type="text" name="search" value="" style='width:150px;height:25px;'/>　　
	         <input name="" type="submit" value="查询" class=""> -->
	         </form>
			<form method='get' action='./bankuailiebiao.php' />　　　
			<input type='text' name='search' / style='height:25px;' />
			<input type='submit' value='提交' style='width:50px;' />
			</form>
		 </td>
		 
		 
		 
		 <td width="10%" align="center" valign="middle" style="text-align:right; width:150px;"><a href="./addUser.php" target="mainFrame" onFocus="this.blur()" class="add"></a></td>
  		</tr>
	</table>
    </td>
  </tr>
  
	<tr>
    <td align="left" valign="top">
    <table width="100%" border="0" cellspacing="0" cellpadding="0" id="main-tab">
      <tr>
        <th align="center" valign="middle" class="borderright tda">顺序</th>
        <th align="center" valign="middle" class="borderright tda">分类树</th>
        <th align="center" valign="middle" class="borderright tda">缩略图</th>
        <th align="center" valign="middle" class="borderright">栏目名</th>
        <th align="center" valign="middle">栏目管理</th>
      </tr>
      
	  <?php
			$con = mysqli_connect('localhost','root','www');
			mysqli_set_charset($con,'utf8');
			mysqli_select_db($con,'admin');
			
			
			//用concat连接字符串,根据mysql中排序规则字符排序  之后加上 limit by 语句   
			$SQL = "select id,name,img,pid,path,concat(path,'-',id) as npath from type {$where} order by npath limit {$start},{$count}";
			$result = mysqli_query($con,$SQL);
			
			$i = 1;
		while($arr = mysqli_fetch_assoc($result)){
			//var_dump($arr);
			//判断是否是否显示子版块
					// pid 的值在这里是字符串类型
			if($arr['pid'] === '0'){
				
			$SQL3 = "select count(*) as counts from type where pid = {$arr['id']}";
			$result3 = mysqli_query($con,$SQL3);
			$arr3 = mysqli_fetch_assoc($result3);	
				//var_dump($arr3['counts']);
			
	  ?>
	  
	  
	  <tr class="bggray">
        <td align="center" valign="middle" class="borderright borderbottom"><input type="text" name="" class="text-word" value="<?php echo $i++; ?>"></td>
        <td align="left" valign="middle" class="borderright borderbottom tdb"><img src="../../public/admin/images/main/dirfirst.gif" width="15" height="13"></td>
        <td align="center" valign="middle" class="borderright borderbottom">&nbsp;</td>
        <td align="left" valign="middle" class="borderright borderbottom tdb"><?php echo $arr['name']; ?></td>
        <td align="center" valign="middle" class="borderbottom">
		<a href="zbk.php?id=<?php echo $arr['id']; ?>" target="mainFrame" onFocus="this.blur()" class="add">添加子模块</a><span class="gray">&nbsp;|&nbsp;</span><a href="./updateFenqu.php?id=<?php echo $arr['id']; ?>" target="mainFrame" onFocus="this.blur()" class="add">修改</a><span class="gray">&nbsp;|&nbsp;</span>
		
		<?php		//判断是否显示删除
					if($arr3['counts'] > 0){
					echo '';
					}else{
		?>
					<a href="./delFenqu.php?id=<?php echo $arr['id']; ?>" target="mainFrame" onFocus="this.blur()" class="add">删除</a></td>';
		<?php
					}
		?>
	 </tr>
      
		<?php
				}else{//如果是子板块的话！ 
		?>
			
		
		 <tr>
			<td align="center" valign="middle" class="borderright borderbottom"><input type="text" name="" class="text-word" value="<?php echo $i++; ?>"></td>
			<td align="left" valign="middle" class="borderright borderbottom tdb">
				<img src="../../public/admin/images/main/dirsecond.gif" width="29" height="29">
			</td>
			<td align="center" valign="middle" class="borderright borderbottom">
				<img src="../../public/admin/images/main/<?php echo $arr['img']; ?>" />
			</td>
			<td align="left" valign="middle" class="borderright borderbottom tdb"><?php echo $arr['name']; ?></td>
			<td align="center" valign="middle" class="borderbottom">
			<a href="../post/tieziliebiao.php" target="mainFrame" onFocus="this.blur()" class="add">查看帖子()	</a><span class="gray">&nbsp;|&nbsp;</span><a href="./updateZBK.php?id=<?php echo $arr['id']; ?>" target="mainFrame" onFocus="this.blur()" class="add">修改</a><span class="gray">&nbsp;|&nbsp;</span>
			
			<a href="add.html" target="mainFrame" onFocus="this.blur()" class="add">删除</a></td>
		</tr>
		

		<?php
				}
		
			}
		
		//判断上一页
		if($nowPage > 1){
			$prevPage = $nowPage - 1;
		}else{
			$prevPage = 1;
		}
		//判断下一页
		$countSQL = "select count(*) as counts2 from type {$where}"; 
		//执行SQL语句 获得多少条数据
		$countResult = mysqli_query($con,$countSQL);
		//将多少条数据提取出来
		$counts = mysqli_fetch_assoc($countResult)['counts2'];
		//显示多少页
		$pages = ceil($counts / $count);
		
		if($nowPage < $pages){
			$nextPage = $nowPage + 1;
		}else{
			$nextPage = $pages;
		}
		
		$shuju = mysqli_num_rows($result);
			
		//关闭数据库
		mysqli_close($con);
		
		?>
	  
	   
    </table></td>
    </tr>
	
	
	
  <tr>
	<td align="left" valign="top" class="fenye"> <?php echo $shuju; ?>条数据 1/1 页&nbsp;&nbsp;
	<a href="./bankuailiebiao.php?page=1" target="mainFrame" onFocus="this.blur()">首页</a>&nbsp;&nbsp;
	<a href="./bankuailiebiao.php?page=<?php echo $prevPage.$url; ?>" target="mainFrame" onFocus="this.blur()">上一页</a>&nbsp;&nbsp;
	<a href="./bankuailiebiao.php?page=<?php echo $nextPage.$url; ?>" target="mainFrame" onFocus="this.blur()">下一页</a>&nbsp;&nbsp;
	<a href="./bankuailiebiao.php?page=<?php echo $pages; ?>" target="mainFrame" onFocus="this.blur()">尾页</a></td>
  </tr>
</table>
</form>
</body>
</html>